clear all
cd "/Users/yasenov/Dropbox (IPL)/RefugeeBan/Data/crime/"

use "offenses_known_yearly_2010_2018.dta"

keep ori number_of_months_missing last_month_reported

keep if number_of_months_missing == 0
unique ori

keep if last_month_reported == "december"
unique ori

bysort ori: keep if _n == 1
keep ori

save "ori_dictionary.dta", replace
